USE NETSYS
Go

DECLARE @QUESTION_TYPE_SHORT char(1)
DECLARE @QUESTION_TYPE_MULTIPLE char(1)

SET @QUESTION_TYPE_SHORT = 'S'
SET @QUESTION_TYPE_MULTIPLE = 'M'

/* Variables to store our identity values after insertion. We'll use
	these to correctly set up our foreign key references. */
DECLARE @LEVEL1_ID INT
DECLARE @LEVEL2_ID INT
DECLARE @LEVEL3_ID INT
DECLARE @LEVEL_Senior_ID INT

DECLARE @QUIZ_ID INT
DECLARE @QUESTION_ID INT
DECLARE @POSITION_ID INT

DECLARE @NETADMIN_CAT_ID INT
DECLARE @NETTHEORY_CAT_ID INT
DECLARE @AD_CAT_ID INT
DECLARE @CH_CAT_ID INT
DECLARE @NT_CAT_ID INT

/* Clear out the tables first so we don't get any duplicate insertion errors. */
DELETE FROM QUESTION_RESULT
DELETE FROM SHORT_ANSWER
DELETE FROM QUESTION
DELETE FROM ANSWER
DELETE FROM QUESTION_LEVEL
DELETE FROM QUESTION_CATEGORY
DELETE FROM POSITION
DELETE FROM QUIZ

/* Question difficulty levels */
INSERT INTO QUESTION_LEVEL(level_description, level_weight) values('Level 1', 1)
SET @LEVEL1_ID = @@IDENTITY
INSERT INTO QUESTION_LEVEL(level_description, level_weight) values('Level 2', 1)
SET @LEVEL2_ID = @@IDENTITY
INSERT INTO QUESTION_LEVEL(level_description, level_weight) values('Level 3', 1)
SET @LEVEL3_ID = @@IDENTITY
INSERT INTO QUESTION_LEVEL(level_description, level_weight) values('Senior', 1)
SET @LEVEL_Senior_ID = @@IDENTITY

/* Question categories */
INSERT INTO QUESTION_CATEGORY(CATEGORY_NAME) VALUES('Network Administration')
SET @NETADMIN_CAT_ID = @@IDENTITY
INSERT INTO QUESTION_CATEGORY(CATEGORY_NAME) VALUES('Active Directory')
SET @AD_CAT_ID = @@IDENTITY
INSERT INTO QUESTION_CATEGORY(CATEGORY_NAME) VALUES('Computer Hardware')
SET @CH_CAT_ID = @@IDENTITY
INSERT INTO QUESTION_CATEGORY(CATEGORY_NAME) VALUES('Network Theory')
SET @NT_CAT_ID = @@IDENTITY

/* Create a TCP/IP Quiz */
INSERT INTO QUIZ(QUIZ_NAME, ALLOW_BACKTRACK) VALUES('TCP/IP Test', 1)
SET @QUIZ_ID = @@IDENTITY

/* Questions and answers for sample questions */

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What does TCP stand for?',
	@QUESTION_TYPE_SHORT,
	@LEVEL1_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

/* Question 1 */
INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following higher-level protocols operate on top of TCP?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL1_ID,
	@NETADMIN_CAT_ID
)
SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'FTP',
	0,
	@QUESTION_ID,
	0
)
INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'HTTP',
	0,
	@QUESTION_ID,
	0
)
INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'SMTP',
	0,
	@QUESTION_ID,
	0
)
INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'All of the above',
	1,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

/* Add some more questions */
INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What function does the ARP protocol perform?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NT_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which protocol in the IP suite of protocols is a connectionless protocol?',
	@QUESTION_TYPE_SHORT,
	@LEVEL1_ID,
	@NT_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'You are troubleshooting an IP communications problem on a PC with the following IP information:
	IP address: 192.168.1.15,
	Subnet Mask: 255.255.255.128,
	Gateway:192.168.254.1,
	What is wrong with the PC? How do you correct it?',
	@QUESTION_TYPE_SHORT,
	@LEVEL3_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'If I need a network with at least 255 available addresses for IP devices, what is the smallest subnet mask I can use?',
	@QUESTION_TYPE_SHORT,
	@LEVEL_Senior_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What do these IP networks have in common?
	10.1.1.0,
	192.168.2.0,
	172.31.0.0',
	@QUESTION_TYPE_SHORT,
	@LEVEL3_ID,
	@NT_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'AT&T gives you this network information: network: 12.19.224.96,
	subnet mask: 255.255.255.240,
	AT&T router: 12.19.224.97. How many IP addresses do you have to assign to devices?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'AT&T gives you this network information: network: 12.19.224.96,
	subnet mask: 255.255.255.240,
	AT&T router: 12.19.224.97. What is the broadcast address?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NT_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'AT&T gives you this network information: network: 12.19.224.96,
	subnet mask: 255.255.255.240,
	AT&T router: 12.19.224.97. What is the gateway?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What protocol automatically assigns IP addresses to devices?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What is a MAC address? Does the TCP/IP protocol use the MAC address?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NT_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'What is CIDR?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'How many layers are in the OSI model? What is Layer 2 of the OSI model?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'An Ethernet switch works with which layer(s) of the OSI model?',
	@QUESTION_TYPE_SHORT,
	@LEVEL2_ID,
	@NETADMIN_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

/* Add a position */

INSERT INTO POSITION(POSITION_TITLE, HIRE_DATE, QUIZ_ID) VALUES(
	'Network Adminstrator - Level I',
	'4/15/2012',
	@QUIZ_ID
)
SET @POSITION_ID = @@IDENTITY

/* Add some applicants to the position */

INSERT INTO APPLICANT(FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, INTERVIEW_DATE, POSITION_ID, APPLICANT_KEY)
VALUES(
	'James',
	'Abendroth',
	'713-111-2222',
	'james@test.com',
	'3/30/2012',
	@POSITION_ID,
	'5970147b-f115-43c3-ac28-ecd09c9d518d'
)

INSERT INTO APPLICANT(FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, INTERVIEW_DATE, POSITION_ID, APPLICANT_KEY)
VALUES(
	'Ankur',
	'Parmar',
	'713-111-3333',
	'ankur@network.com',
	'3/29/2012',
	@POSITION_ID,
	'c6a9ddc7-9845-46be-bc7d-f194a42e8cf7'
)


/* Create an Active Directory Quiz */
INSERT INTO QUIZ(QUIZ_NAME, ALLOW_BACKTRACK) VALUES('Active Directory Group Policy Quiz', 0)
SET @QUIZ_ID = @@IDENTITY

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'
	You are the network administrator for Contoso, Ltd. The network consists of a single Active Directory domain,
	contoso.com. All network servers run Windows Server 2003. All client computers run Windows XP Professional.
	Contoso has a location in London and a location in Brussels. Each location is configured as an Active Directory
	site and has two domain controllers. Before users can log in, a legal notice must be displayed on the local desktop.
	Users receive the notice and then log in. The legal department informs you that a new notice must be put in effect immediately.
	You make the change to the text and apply Group Policy using the gpupdate tool.
	Users in London receive the new notice, but a week later, users in Brussels are still receiving the old notice.
	What should you do?
	',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@AD_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Temporarily assign one of the London domain controllers to the Brussels site. Reassign the domain controller to London after 24 hours.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Force Active Directory replication between the sites.',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'From a London domain controller, log onto a Brussels domain controller and seize the infrastructure master role.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new security group for all of the Brussels client computers. Grant this group permission to read and apply the Group Policy Object (GPO).',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new security group for all of the Brussels computers. Grant this group permission to read and apply the Group Policy Object (GPO).',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'
	You are the network administrator for Contoso, Ltd. The network consists of a single Active Directory domain, contoso.com.
	All network servers run Windows Server 2003.
	All client computers run Windows XP Professional. 
	Users in the Sales department are members of the Sales security group and the Sales Users organizational unit (OU).
	Contoso purchases a new Customer Relationship Management (CRM) application that must be installed on all client
	computers in the Sales Users OU.
	The application is bundled in a .msi file which you have copied to a shared folder named \\Server1\SalesApps.
	You have assigned the Sales group the Allow - Read permission for the SalesApps share.
	Now you need to enable Sales users to download and install the application on their own computers.
	What will you do?
	',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@AD_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new Group Policy Object (GPO) linked to the Sales Users OU. Enable the Always install with elevated privileges
	setting in the Windows Installer node under the Computer Configuration node. Instruct users to launch the .msi file in the
	\\Server1\SalesApps folder.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new Group Policy Object (GPO) linked to the Sales Users OU. Disable the Never install with elevated privileges
	setting in the Windows Installer node under the Computer Configuration node.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new Group Policy Object (GPO) linked to the Sales Users OU. Assign the new application to all client computers.',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Create a new Group Policy Object (GPO) linked to the Sales Users OU. Enable a policy that reates a link to the shortcut
	for the installation executable. Grant permission to the Sales users to create temporary files in the \\Server1\SalesApps folder.',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'
	You are the network administrator for Contoso, Ltd. The network consists of a single Active Directory domain, contoso.com.
	Contoso has locations in Atlanta and Chicago.
	Each location has two domain controllers. A new user application needs to be deployed to corporate users. You create a new
	Group Policy Object (GPO) named App1 and link it to the domain.
	You configure the User Configuration node of App1 to assign the application. Users in Atlanta report that the application
	is not available. Users in Chicago can use the application.
	You need to make the application available to all users.
	What will you do?
	',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@AD_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Run the gpresult command on domain controllers in Atlanta.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Run the gporesult command on domain controllers in Atlanta.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Run the gpotool command on domain controllers in Atlanta.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Run the gpupdate command on domain controllers in Atlanta.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Force directory replication between all domain controllers in the domain.',
	1,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'
	You are the network administrator for Contoso, Ltd. The network consists of a single Active Directory domain, contoso.com.
	The domain functional level is Windows Server 2003.
	All network servers run Windows Server 2003. All client computers run Windows XP Professional. Built-in groups are
	installed with the default memberships.
	There are two domain controllers in the domain. Domain controllers are backed up nightly. You are testing some Group
	Policy changes to enhance security.
	You accidentally disable the local Administrator account in the Default Domain Policy Group Policy Object (GPO).
	You are no longer able to log onto either of the domain controllers as Administrator.
	What should you do?
	',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@AD_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Restore the entire hard disk of one of the domain controllers using the last full backup preceding the change to the
	Default Domain Policy. Restart the domain controller. Allow Active Directory replication to take place.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Restart one of the domain controllers in Safe mode. Log on locally as Administrator. Create a second administrator account.
	Restart the domain controller. Use the new administrator account to undo the change to the Default Domain Policy.',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Restart one of the domain controllers in Directory Services Restore Mode. Perform an authoritative restore of the Domain
	Controllers organizational unit (OU) using the last full backup preceding the change to the Default Domain Policy.
	Restart the domain controller.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Restart one of the domain controllers and run the Recovery Console from the Windows Server 2003 CD. Stop the GPC service.
	Restart the domain controller.',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

/* Add another position */
INSERT INTO POSITION(POSITION_TITLE, HIRE_DATE, QUIZ_ID) VALUES(
	'Windows Active Directory Administrator',
	'6/30/2012',
	@QUIZ_ID
)
SET @POSITION_ID = @@IDENTITY

/* Add an applicant to the position */
INSERT INTO APPLICANT(FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, INTERVIEW_DATE, POSITION_ID, APPLICANT_KEY)
VALUES(
	'Jacob',
	'Netzband',
	'713-111-4444',
	'jacob@somewebsite.com',
	'4/1/2012',
	@POSITION_ID,
	'935de160-9858-46b5-924f-e34b52bc1a2c'
)

/* Add an A+ quiz */
INSERT INTO QUIZ(QUIZ_NAME, ALLOW_BACKTRACK) VALUES('A+ Quiz', 0)
SET @QUIZ_ID = @@IDENTITY

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following is the local user with the MOST authority on a computer running Windows XP?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@AD_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'BCM user',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Power user',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Network Configuration Operator',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Administrator',
	1,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following modes will provide retrieval of a previous computing session with the least amount of boot-up time?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Shutdown',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Hibernate',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Standby',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Restart',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)
---
INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following will happen when a user plugs a third-party adapter which outputs alternating current (AC) directly into a laptop?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The laptop will start in Safe Mode.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The laptop will start, however it will not charge the battery.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The laptop processor will be overclocked.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The laptop components will be damaged.',
	1,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)
---
INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following is a way to identify which Windows operating system is currently installed?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Click on Start > Run and type version/info',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Right click My Computer > Properties',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Click on Start > Run and type version info/detail',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Right click My Computer > Manage',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)
---
INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'In Windows XP, which of the following utilities is used to partition the disk?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Disk Management',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'System Configuration Utility',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Registry Editor',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Device Manager',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'An older printer is connected to a computer using a parallel port. Which of the following
	connectors is MOST likely used on the computers parallel port?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'DB-50 connector',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'DB-25 pin connector',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'DB-9 pin connector',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'DB-37 connector',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'Which of the following IP classes is the IP address 200.168.212.226 an example of?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Class C',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Class A',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Class B',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Class D',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'The standard connector used for an UTP Ethernet connection is:',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'DB-9',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'RJ-45',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'BNC',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'RJ-11',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'A user reports that the computer keeps freezing. Which of the following information should the technician obtain FIRST?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The model number of the users computer',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Windows Error Reporting Log',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'The type of machine, whether it is a laptop or a desktop',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'What the user was doing when the problem occurred',
	1,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

INSERT INTO QUESTION(QUESTION_TEXT, QUESTION_TYPE, LEVEL_ID, CATEGORY_ID) VALUES(
	'A user reports an issue that does not occur while the technician is onsite. Which of the following actions should the technician perform while troubleshooting this issue with the user?',
	@QUESTION_TYPE_MULTIPLE,
	@LEVEL2_ID,
	@CH_CAT_ID
)

SET @QUESTION_ID = @@IDENTITY

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Ask the user which web sites they have been viewing.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Tell the user that the problem is usually related to user training.',
	0,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Ask the user a series of questions designed to narrow the scope of the problem.',
	1,
	@QUESTION_ID,
	0
)

INSERT INTO ANSWER(ANSWER_TEXT, IS_CORRECT_ANSWER, QUESTION_ID, ANSWER_PRIORITY) VALUES(
	'Tell the user that the technician will solve the problem quickly.',
	0,
	@QUESTION_ID,
	0
)

/* Link the question to the quiz */
INSERT INTO QUIZ_QUESTION(QUESTION_ID, QUIZ_ID, QUESTION_PRIORITY) VALUES(
	@QUESTION_ID,
	@QUIZ_ID,
	0
)

/* Add another position */
INSERT INTO POSITION(POSITION_TITLE, HIRE_DATE, QUIZ_ID) VALUES(
	'Windows Active Directory Administrator',
	'5/30/2012',
	@QUIZ_ID
)
SET @POSITION_ID = @@IDENTITY

/* Add an applicant to the position */
INSERT INTO APPLICANT(FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, INTERVIEW_DATE, POSITION_ID, APPLICANT_KEY)
VALUES(
	'David',
	'Carr',
	'713-212-9876',
	'david@test.com',
	'6/1/2012',
	@POSITION_ID,
	'a0d5b597-326f-4a1f-cd88-hc1b72723127'
)

/* Add another applicant to the position */
INSERT INTO APPLICANT(FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, INTERVIEW_DATE, POSITION_ID, APPLICANT_KEY)
VALUES(
	'Joseph',
	'Young',
	'713-112-5678',
	'joseph@google.com',
	'6/2/2012',
	@POSITION_ID,
	'f0f5b597-325f-411f-bd88-fc1b92723803'
)